﻿ <table width="193" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="193" height="24"><img src="images/hot_title.jpg" width="193" height="24"></td>
  </tr>
</table>
<table width="193" border="0" cellpadding="0" cellspacing="0">
<!--循环开始-->
<%
dim rs2,sql2	
set rs2=server.createobject("adodb.recordset") 
sql2="select * from shop ORDER BY hits DESC, id DESC" 
rs2.open sql2,conn,1,1 
if rs2.eof then
response.Write "&nbsp;暂无产品！"
end if

For i=1 To hot_num
if rs2.eof then exit for	
%>
  <tr>
    <td width="70" height="70" align="right" valign="middle"><a href="showshop.asp?/<%=rs2("id")%>.html" title="<%=rs2("title")%>" class="img"><img src="<%=rs2("img")%>" width="55" height="55" border="0" /></a></td>
    <td width="123" height="70">
    <table width="123" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="20" align="left"><a href="showshop.asp?/<%=rs2("id")%>.html" title="<%=rs2("title")%>" ><%=left(rs2("title"),18)%></a></td>
      </tr>
      <tr>
        <td height="20" align="left" style="color:#408109; font-weight:bold; font-size:14px;">Hits:<%=rs2("hits")%></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td colspan="2"><img src="images/left_02_04.jpg" width="193" height="3" /></td>
  </tr>
<%
rs2.movenext 
next
rs2.close
set rs2=nothing
%>
</table>